package com.xiaochang.em.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.xiaochang.em.entity.Example;
import com.xiaochang.em.entity.Star;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface ExampleMapper extends BaseMapper<Example> {

    //查看全部
    @Select("select example.starid, star_data.obsid, star_data.subclass, " +
            "star_data.z, star_data.ra, star_data.dec," +
            "star_data.logg, star_data.rv " +
            "from star_data inner join example on star_data.id = example.starid")
    List<Example> allExample();

}
